 CREATE TABLE "TB_CM_SHOP_INF" 
   (	"BILLTO_CODE" NVARCHAR(50), 
	"SHOP_CODE" NVARCHAR(8), 
	"SHOP_NAME" NVARCHAR(100), 
	"ADDRESS" NVARCHAR(500), 
	"CELL_NO#1" NVARCHAR(20), 
	"DIST_CODE" NVARCHAR(5), 
	"PROVINCE_CODE" NVARCHAR(5), 
	"CREATE_DATE" DATE, 
	"UPDATE_DATE" DATE, 
	"ISDN_NO" NVARCHAR(20), 
	"CUSTOMER_CODE" NVARCHAR(50), 
	"AREA_CODE" NVARCHAR(2), 
	"CELL_NO#2" NVARCHAR(20), 
	"OWNER_NAME" NVARCHAR(100), 
	"OWNER_EMAIL" NVARCHAR(100), 
	"USE_FLAG" NVARCHAR(1) DEFAULT 'Y', 
	"CHANNEL" NVARCHAR(1) DEFAULT 'N', 
	"REG_ID" NVARCHAR(2), 
	"CREATE_USER" NVARCHAR(10), 
	"UPDATE_USER" NVARCHAR(10), 
	"SHOP_TYPE" NVARCHAR(10) DEFAULT 'SUB-D', 
	"SO_TRANSFER_FLAG" NVARCHAR(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ; 